<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Allowing Excel to automatically change row height</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Saving, exporting, emailing, or printing a report or document\nExporting a report or document\nExporting Documents\nAllowing Excel to automatically change row height");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Allowing Excel to automatically change row height</h1>
<p>When you export a document that contains a Grid/Graph to Excel, some 
 of the data can be too long to fit inside an Excel cell. The text wraps 
 within the cell, but the row is too short and cuts off the text. If this 
 occurs, you can allow Excel to dynamically and automatically resize. The 
 rows are resized so that they are tall enough to display the full text. 
 </p>
<p>By default, the height of all rows are the same, to conserve the same 
 layout that you created in the document. To modify the behavior, change 
 the <span style="font-weight: bold;"><B>Automatically fit rows</B></span> property 
 to <span style="font-weight: bold;"><B>True</B></span>. This property applies 
 to a single document section.</p>
<h2>To allow Excel to automatically change row height for a section</h2>
<ol><ol start=1>
<li class=p-First-Steps-Do-Not-Type-Text><p class=First-Steps-Do-Not-Type-Text>&nbsp;</p></li>
	</ol>
	
<li class=p-Steps><p class=Steps>Open the document in the Document 
 Editor.</p></li>
	
<li class=p-Steps><p class=Steps>In the Layout area, select the document 
 section to modify.</p></li>
	
<li class=p-Steps><p class=Steps>From the <span style="font-weight: bold;"><B>Format</B></span> 
 menu, select <span style="font-weight: bold;"><B>Properties</B></span>. The Properties 
 dialog box opens.</p></li>
	
<li class=p-Steps><p class=Steps>Click the <span style="font-weight: bold;"><B>Layout</B></span> 
 tab.</p></li>
	
<li class=p-Steps><p class=Steps>Select the <span style="font-weight: bold;"><B>Automatically 
 fit rows</B></span> check box.</p></li>
	
<li class=p-Steps><p class=Steps>Click <span style="font-weight: bold;"><B>OK</B></span> 
 to return to the document.</p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
